package com.hydl.power.pojo;

import java.util.ArrayList;
import java.util.List;

public class DeviceExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public DeviceExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andModuleIdIsNull() {
            addCriterion("module_id is null");
            return (Criteria) this;
        }

        public Criteria andModuleIdIsNotNull() {
            addCriterion("module_id is not null");
            return (Criteria) this;
        }

        public Criteria andModuleIdEqualTo(Integer value) {
            addCriterion("module_id =", value, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdNotEqualTo(Integer value) {
            addCriterion("module_id <>", value, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdGreaterThan(Integer value) {
            addCriterion("module_id >", value, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("module_id >=", value, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdLessThan(Integer value) {
            addCriterion("module_id <", value, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdLessThanOrEqualTo(Integer value) {
            addCriterion("module_id <=", value, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdIn(List<Integer> values) {
            addCriterion("module_id in", values, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdNotIn(List<Integer> values) {
            addCriterion("module_id not in", values, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdBetween(Integer value1, Integer value2) {
            addCriterion("module_id between", value1, value2, "moduleId");
            return (Criteria) this;
        }

        public Criteria andModuleIdNotBetween(Integer value1, Integer value2) {
            addCriterion("module_id not between", value1, value2, "moduleId");
            return (Criteria) this;
        }

        public Criteria andFullnameIsNull() {
            addCriterion("fullName is null");
            return (Criteria) this;
        }

        public Criteria andFullnameIsNotNull() {
            addCriterion("fullName is not null");
            return (Criteria) this;
        }

        public Criteria andFullnameEqualTo(String value) {
            addCriterion("fullName =", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameNotEqualTo(String value) {
            addCriterion("fullName <>", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameGreaterThan(String value) {
            addCriterion("fullName >", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameGreaterThanOrEqualTo(String value) {
            addCriterion("fullName >=", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameLessThan(String value) {
            addCriterion("fullName <", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameLessThanOrEqualTo(String value) {
            addCriterion("fullName <=", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameLike(String value) {
            addCriterion("fullName like", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameNotLike(String value) {
            addCriterion("fullName not like", value, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameIn(List<String> values) {
            addCriterion("fullName in", values, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameNotIn(List<String> values) {
            addCriterion("fullName not in", values, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameBetween(String value1, String value2) {
            addCriterion("fullName between", value1, value2, "fullname");
            return (Criteria) this;
        }

        public Criteria andFullnameNotBetween(String value1, String value2) {
            addCriterion("fullName not between", value1, value2, "fullname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameIsNull() {
            addCriterion("powerRoomName is null");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameIsNotNull() {
            addCriterion("powerRoomName is not null");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameEqualTo(String value) {
            addCriterion("powerRoomName =", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameNotEqualTo(String value) {
            addCriterion("powerRoomName <>", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameGreaterThan(String value) {
            addCriterion("powerRoomName >", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameGreaterThanOrEqualTo(String value) {
            addCriterion("powerRoomName >=", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameLessThan(String value) {
            addCriterion("powerRoomName <", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameLessThanOrEqualTo(String value) {
            addCriterion("powerRoomName <=", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameLike(String value) {
            addCriterion("powerRoomName like", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameNotLike(String value) {
            addCriterion("powerRoomName not like", value, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameIn(List<String> values) {
            addCriterion("powerRoomName in", values, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameNotIn(List<String> values) {
            addCriterion("powerRoomName not in", values, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameBetween(String value1, String value2) {
            addCriterion("powerRoomName between", value1, value2, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomnameNotBetween(String value1, String value2) {
            addCriterion("powerRoomName not between", value1, value2, "powerroomname");
            return (Criteria) this;
        }

        public Criteria andPowerroomidIsNull() {
            addCriterion("powerRoomId is null");
            return (Criteria) this;
        }

        public Criteria andPowerroomidIsNotNull() {
            addCriterion("powerRoomId is not null");
            return (Criteria) this;
        }

        public Criteria andPowerroomidEqualTo(Integer value) {
            addCriterion("powerRoomId =", value, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidNotEqualTo(Integer value) {
            addCriterion("powerRoomId <>", value, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidGreaterThan(Integer value) {
            addCriterion("powerRoomId >", value, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidGreaterThanOrEqualTo(Integer value) {
            addCriterion("powerRoomId >=", value, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidLessThan(Integer value) {
            addCriterion("powerRoomId <", value, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidLessThanOrEqualTo(Integer value) {
            addCriterion("powerRoomId <=", value, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidIn(List<Integer> values) {
            addCriterion("powerRoomId in", values, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidNotIn(List<Integer> values) {
            addCriterion("powerRoomId not in", values, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidBetween(Integer value1, Integer value2) {
            addCriterion("powerRoomId between", value1, value2, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andPowerroomidNotBetween(Integer value1, Integer value2) {
            addCriterion("powerRoomId not between", value1, value2, "powerroomid");
            return (Criteria) this;
        }

        public Criteria andDisabledIsNull() {
            addCriterion("disabled is null");
            return (Criteria) this;
        }

        public Criteria andDisabledIsNotNull() {
            addCriterion("disabled is not null");
            return (Criteria) this;
        }

        public Criteria andDisabledEqualTo(String value) {
            addCriterion("disabled =", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotEqualTo(String value) {
            addCriterion("disabled <>", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledGreaterThan(String value) {
            addCriterion("disabled >", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledGreaterThanOrEqualTo(String value) {
            addCriterion("disabled >=", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledLessThan(String value) {
            addCriterion("disabled <", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledLessThanOrEqualTo(String value) {
            addCriterion("disabled <=", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledLike(String value) {
            addCriterion("disabled like", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotLike(String value) {
            addCriterion("disabled not like", value, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledIn(List<String> values) {
            addCriterion("disabled in", values, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotIn(List<String> values) {
            addCriterion("disabled not in", values, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledBetween(String value1, String value2) {
            addCriterion("disabled between", value1, value2, "disabled");
            return (Criteria) this;
        }

        public Criteria andDisabledNotBetween(String value1, String value2) {
            addCriterion("disabled not between", value1, value2, "disabled");
            return (Criteria) this;
        }

        public Criteria andModulenameIsNull() {
            addCriterion("moduleName is null");
            return (Criteria) this;
        }

        public Criteria andModulenameIsNotNull() {
            addCriterion("moduleName is not null");
            return (Criteria) this;
        }

        public Criteria andModulenameEqualTo(String value) {
            addCriterion("moduleName =", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameNotEqualTo(String value) {
            addCriterion("moduleName <>", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameGreaterThan(String value) {
            addCriterion("moduleName >", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameGreaterThanOrEqualTo(String value) {
            addCriterion("moduleName >=", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameLessThan(String value) {
            addCriterion("moduleName <", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameLessThanOrEqualTo(String value) {
            addCriterion("moduleName <=", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameLike(String value) {
            addCriterion("moduleName like", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameNotLike(String value) {
            addCriterion("moduleName not like", value, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameIn(List<String> values) {
            addCriterion("moduleName in", values, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameNotIn(List<String> values) {
            addCriterion("moduleName not in", values, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameBetween(String value1, String value2) {
            addCriterion("moduleName between", value1, value2, "modulename");
            return (Criteria) this;
        }

        public Criteria andModulenameNotBetween(String value1, String value2) {
            addCriterion("moduleName not between", value1, value2, "modulename");
            return (Criteria) this;
        }

        public Criteria andModuleaddrIsNull() {
            addCriterion("moduleAddr is null");
            return (Criteria) this;
        }

        public Criteria andModuleaddrIsNotNull() {
            addCriterion("moduleAddr is not null");
            return (Criteria) this;
        }

        public Criteria andModuleaddrEqualTo(String value) {
            addCriterion("moduleAddr =", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrNotEqualTo(String value) {
            addCriterion("moduleAddr <>", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrGreaterThan(String value) {
            addCriterion("moduleAddr >", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrGreaterThanOrEqualTo(String value) {
            addCriterion("moduleAddr >=", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrLessThan(String value) {
            addCriterion("moduleAddr <", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrLessThanOrEqualTo(String value) {
            addCriterion("moduleAddr <=", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrLike(String value) {
            addCriterion("moduleAddr like", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrNotLike(String value) {
            addCriterion("moduleAddr not like", value, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrIn(List<String> values) {
            addCriterion("moduleAddr in", values, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrNotIn(List<String> values) {
            addCriterion("moduleAddr not in", values, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrBetween(String value1, String value2) {
            addCriterion("moduleAddr between", value1, value2, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuleaddrNotBetween(String value1, String value2) {
            addCriterion("moduleAddr not between", value1, value2, "moduleaddr");
            return (Criteria) this;
        }

        public Criteria andModuletypeIsNull() {
            addCriterion("moduleType is null");
            return (Criteria) this;
        }

        public Criteria andModuletypeIsNotNull() {
            addCriterion("moduleType is not null");
            return (Criteria) this;
        }

        public Criteria andModuletypeEqualTo(String value) {
            addCriterion("moduleType =", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeNotEqualTo(String value) {
            addCriterion("moduleType <>", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeGreaterThan(String value) {
            addCriterion("moduleType >", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeGreaterThanOrEqualTo(String value) {
            addCriterion("moduleType >=", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeLessThan(String value) {
            addCriterion("moduleType <", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeLessThanOrEqualTo(String value) {
            addCriterion("moduleType <=", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeLike(String value) {
            addCriterion("moduleType like", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeNotLike(String value) {
            addCriterion("moduleType not like", value, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeIn(List<String> values) {
            addCriterion("moduleType in", values, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeNotIn(List<String> values) {
            addCriterion("moduleType not in", values, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeBetween(String value1, String value2) {
            addCriterion("moduleType between", value1, value2, "moduletype");
            return (Criteria) this;
        }

        public Criteria andModuletypeNotBetween(String value1, String value2) {
            addCriterion("moduleType not between", value1, value2, "moduletype");
            return (Criteria) this;
        }

        public Criteria andEspipIsNull() {
            addCriterion("espIp is null");
            return (Criteria) this;
        }

        public Criteria andEspipIsNotNull() {
            addCriterion("espIp is not null");
            return (Criteria) this;
        }

        public Criteria andEspipEqualTo(String value) {
            addCriterion("espIp =", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipNotEqualTo(String value) {
            addCriterion("espIp <>", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipGreaterThan(String value) {
            addCriterion("espIp >", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipGreaterThanOrEqualTo(String value) {
            addCriterion("espIp >=", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipLessThan(String value) {
            addCriterion("espIp <", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipLessThanOrEqualTo(String value) {
            addCriterion("espIp <=", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipLike(String value) {
            addCriterion("espIp like", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipNotLike(String value) {
            addCriterion("espIp not like", value, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipIn(List<String> values) {
            addCriterion("espIp in", values, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipNotIn(List<String> values) {
            addCriterion("espIp not in", values, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipBetween(String value1, String value2) {
            addCriterion("espIp between", value1, value2, "espip");
            return (Criteria) this;
        }

        public Criteria andEspipNotBetween(String value1, String value2) {
            addCriterion("espIp not between", value1, value2, "espip");
            return (Criteria) this;
        }

        public Criteria andEspportIsNull() {
            addCriterion("espPort is null");
            return (Criteria) this;
        }

        public Criteria andEspportIsNotNull() {
            addCriterion("espPort is not null");
            return (Criteria) this;
        }

        public Criteria andEspportEqualTo(String value) {
            addCriterion("espPort =", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportNotEqualTo(String value) {
            addCriterion("espPort <>", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportGreaterThan(String value) {
            addCriterion("espPort >", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportGreaterThanOrEqualTo(String value) {
            addCriterion("espPort >=", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportLessThan(String value) {
            addCriterion("espPort <", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportLessThanOrEqualTo(String value) {
            addCriterion("espPort <=", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportLike(String value) {
            addCriterion("espPort like", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportNotLike(String value) {
            addCriterion("espPort not like", value, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportIn(List<String> values) {
            addCriterion("espPort in", values, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportNotIn(List<String> values) {
            addCriterion("espPort not in", values, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportBetween(String value1, String value2) {
            addCriterion("espPort between", value1, value2, "espport");
            return (Criteria) this;
        }

        public Criteria andEspportNotBetween(String value1, String value2) {
            addCriterion("espPort not between", value1, value2, "espport");
            return (Criteria) this;
        }

        public Criteria andEspaddrIsNull() {
            addCriterion("espAddr is null");
            return (Criteria) this;
        }

        public Criteria andEspaddrIsNotNull() {
            addCriterion("espAddr is not null");
            return (Criteria) this;
        }

        public Criteria andEspaddrEqualTo(String value) {
            addCriterion("espAddr =", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrNotEqualTo(String value) {
            addCriterion("espAddr <>", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrGreaterThan(String value) {
            addCriterion("espAddr >", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrGreaterThanOrEqualTo(String value) {
            addCriterion("espAddr >=", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrLessThan(String value) {
            addCriterion("espAddr <", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrLessThanOrEqualTo(String value) {
            addCriterion("espAddr <=", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrLike(String value) {
            addCriterion("espAddr like", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrNotLike(String value) {
            addCriterion("espAddr not like", value, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrIn(List<String> values) {
            addCriterion("espAddr in", values, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrNotIn(List<String> values) {
            addCriterion("espAddr not in", values, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrBetween(String value1, String value2) {
            addCriterion("espAddr between", value1, value2, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspaddrNotBetween(String value1, String value2) {
            addCriterion("espAddr not between", value1, value2, "espaddr");
            return (Criteria) this;
        }

        public Criteria andEspIdIsNull() {
            addCriterion("esp_id is null");
            return (Criteria) this;
        }

        public Criteria andEspIdIsNotNull() {
            addCriterion("esp_id is not null");
            return (Criteria) this;
        }

        public Criteria andEspIdEqualTo(Integer value) {
            addCriterion("esp_id =", value, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdNotEqualTo(Integer value) {
            addCriterion("esp_id <>", value, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdGreaterThan(Integer value) {
            addCriterion("esp_id >", value, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("esp_id >=", value, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdLessThan(Integer value) {
            addCriterion("esp_id <", value, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdLessThanOrEqualTo(Integer value) {
            addCriterion("esp_id <=", value, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdIn(List<Integer> values) {
            addCriterion("esp_id in", values, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdNotIn(List<Integer> values) {
            addCriterion("esp_id not in", values, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdBetween(Integer value1, Integer value2) {
            addCriterion("esp_id between", value1, value2, "espId");
            return (Criteria) this;
        }

        public Criteria andEspIdNotBetween(Integer value1, Integer value2) {
            addCriterion("esp_id not between", value1, value2, "espId");
            return (Criteria) this;
        }

        public Criteria andAttribIsNull() {
            addCriterion("Attrib is null");
            return (Criteria) this;
        }

        public Criteria andAttribIsNotNull() {
            addCriterion("Attrib is not null");
            return (Criteria) this;
        }

        public Criteria andAttribEqualTo(String value) {
            addCriterion("Attrib =", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribNotEqualTo(String value) {
            addCriterion("Attrib <>", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribGreaterThan(String value) {
            addCriterion("Attrib >", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribGreaterThanOrEqualTo(String value) {
            addCriterion("Attrib >=", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribLessThan(String value) {
            addCriterion("Attrib <", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribLessThanOrEqualTo(String value) {
            addCriterion("Attrib <=", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribLike(String value) {
            addCriterion("Attrib like", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribNotLike(String value) {
            addCriterion("Attrib not like", value, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribIn(List<String> values) {
            addCriterion("Attrib in", values, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribNotIn(List<String> values) {
            addCriterion("Attrib not in", values, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribBetween(String value1, String value2) {
            addCriterion("Attrib between", value1, value2, "attrib");
            return (Criteria) this;
        }

        public Criteria andAttribNotBetween(String value1, String value2) {
            addCriterion("Attrib not between", value1, value2, "attrib");
            return (Criteria) this;
        }

        public Criteria andMmIdIsNull() {
            addCriterion("Mm_id is null");
            return (Criteria) this;
        }

        public Criteria andMmIdIsNotNull() {
            addCriterion("Mm_id is not null");
            return (Criteria) this;
        }

        public Criteria andMmIdEqualTo(Integer value) {
            addCriterion("Mm_id =", value, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdNotEqualTo(Integer value) {
            addCriterion("Mm_id <>", value, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdGreaterThan(Integer value) {
            addCriterion("Mm_id >", value, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("Mm_id >=", value, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdLessThan(Integer value) {
            addCriterion("Mm_id <", value, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdLessThanOrEqualTo(Integer value) {
            addCriterion("Mm_id <=", value, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdIn(List<Integer> values) {
            addCriterion("Mm_id in", values, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdNotIn(List<Integer> values) {
            addCriterion("Mm_id not in", values, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdBetween(Integer value1, Integer value2) {
            addCriterion("Mm_id between", value1, value2, "mmId");
            return (Criteria) this;
        }

        public Criteria andMmIdNotBetween(Integer value1, Integer value2) {
            addCriterion("Mm_id not between", value1, value2, "mmId");
            return (Criteria) this;
        }

        public Criteria andIeIsNull() {
            addCriterion("Ie is null");
            return (Criteria) this;
        }

        public Criteria andIeIsNotNull() {
            addCriterion("Ie is not null");
            return (Criteria) this;
        }

        public Criteria andIeEqualTo(String value) {
            addCriterion("Ie =", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeNotEqualTo(String value) {
            addCriterion("Ie <>", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeGreaterThan(String value) {
            addCriterion("Ie >", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeGreaterThanOrEqualTo(String value) {
            addCriterion("Ie >=", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeLessThan(String value) {
            addCriterion("Ie <", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeLessThanOrEqualTo(String value) {
            addCriterion("Ie <=", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeLike(String value) {
            addCriterion("Ie like", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeNotLike(String value) {
            addCriterion("Ie not like", value, "ie");
            return (Criteria) this;
        }

        public Criteria andIeIn(List<String> values) {
            addCriterion("Ie in", values, "ie");
            return (Criteria) this;
        }

        public Criteria andIeNotIn(List<String> values) {
            addCriterion("Ie not in", values, "ie");
            return (Criteria) this;
        }

        public Criteria andIeBetween(String value1, String value2) {
            addCriterion("Ie between", value1, value2, "ie");
            return (Criteria) this;
        }

        public Criteria andIeNotBetween(String value1, String value2) {
            addCriterion("Ie not between", value1, value2, "ie");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}